package cc.rengu.redp.bizimpl.upmp.dao;

import cc.rengu.redp.bizimpl.upmp.domain.RegionInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author LiuYuLiang.LL
 */
public interface RegionInfoMapper extends BaseMapper<RegionInfo> {

    @Select("select REGION_CODE ||'-'|| REGION_NAME as AREA_INF from T_B_REGION_INFO b where REGION_LEVEL ='03' " +
            "and STATUS='01' and PARENT_CODE = #{areaCd}")
    List<String> getXjCountry(@Param("areaCd") String areaCd);
}
